import tushare as ts
from sqlalchemy import create_engine
from sqlalchemy.types import String
engine = create_engine('mysql://root:123@172.17.0.2/db_stock?charset=utf8')

pro = ts.pro_api()
all_stock = pro.stock_basic()
pass
all_stock.to_sql('all_stocks', engine, dtype=String(50))
